<TestCase testName="Test_08_OracleDBQuery">

<!-- This test case has been exercised using the HR schema available in Oracle express edition-->
	<TestSetup>
	</TestSetup>
	
	<TestExecution>
	
		<TestStep assemblyPath="BizUnit.Extensions.Oracle.dll" typeName="BizUnit.Extensions.Oracle.OracleDBQueryStep">
			<DelayBeforeCheck>0</DelayBeforeCheck>
			<ConnectionString>connectionstring</ConnectionString>
					
			<!-- 
			The SQL Query to execute is built by formatting the RawSQLQuery substituting in the 
			SQLQueryParam's
			-->
			<SQLQuery>
				<RawSQLQuery>SELECT COUNTRY_NAME, REGION_ID FROM COUNTRIES WHERE COUNTRY_ID= '{0}'</RawSQLQuery>
				<SQLQueryParams>
					<SQLQueryParam >AR</SQLQueryParam>
				</SQLQueryParams>
			</SQLQuery>

			<!-- 
				Note: The column names are dependant on the DB schema being checked against.
				Adding the attribute isUnique="true" to one of the columns allows it to be 
				uniquely selcted in the scenario where multiple rows are returned.
				-->

			<Rows>
				<Columns>
					<COUNTRY_NAME>Argentina</COUNTRY_NAME>
					<REGION_ID>2</REGION_ID>
				</Columns>
			</Rows>	
		</TestStep>	
		
	</TestExecution>

	<!-- Test cleanup: test cases should always leave the system in the state they found it -->
	<TestCleanup>
	</TestCleanup>	
	
</TestCase>

